﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using DBUtility;

namespace DAL
{
    public class DGpsHistory
    {
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strEmi,DateTime startTime,DateTime endTime)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Lat,Lng,State,Angle,Speed,UpdateTime ");
            strSql.Append(" FROM tdevicegpshistory ");
            strSql.Append("where Emi='");
            strSql.Append(strEmi);
            strSql.Append("' and UpdateTime between '");
            strSql.Append(startTime);
            strSql.Append("' and '");
            strSql.Append(endTime);
            strSql.Append("';");
            return DbHelperMySQL.Query(strSql.ToString());
        }


    }
}
